<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
 <head><title>用户列表页</title>
    <script  src="../js/jquery-2.1.4.js"></script>
  
     <link rel="stylesheet" href="../css/lanrenzhijia.css" media="all">
           <link href="http://libs.baidu.com/bootstrap/3.0.3/css/bootstrap.min.css" rel="stylesheet">
   <script src="http://libs.baidu.com/bootstrap/3.0.3/js/bootstrap.min.js"></script>
<script>
jQuery(document).ready(function($) {
	$('.theme-login').click(function(){
		$('.theme-popover-mask').fadeIn(100);
		$('.theme-popover').slideDown(200);
	});
	$('.theme-poptit .close').click(function(){
		$('.theme-popover-mask').fadeOut(100);
		$('.theme-popover').slideUp(200);
	});
    
});
$(document).ready(function(){
	$('.user3').click(function(){
		$('#comId1').attr("value",$(this).attr('id'));
	});
});
</script>
</head>
<body >
<div style="padding-left: 15px;height:auto;width:99%;" >
<h1>评论管理</h1><hr>
    <div  >
<form action="commentMan_list_delete.jsp" method="post" >
<table class="table table-bordered">
   <thead>
      <tr>
         <th>用户名</th>
         <th>产品编号</th>
         <th>举报内容</th>
         <th>举报时间</th>
         <th>状态</th>
         <th>处理举报信息</th>
      </tr>
   </thead>    
         <tbody> 
      <% ResultSet rs=null;
        Statement statement=null;
        try{
        Driver driver=new com.mysql.jdbc.Driver();
        DriverManager.registerDriver(driver);
         Connection connection=DriverManager.getConnection("jdbc:mysql://www.ccjjltx.cn:3307/numbersystem?useUnicode=true&characterEncoding=utf8","root","usbw");
         String sql="select * from report_manage";  //创建执行语句
         statement=connection.createStatement();
         rs=statement.executeQuery(sql);
         while(rs.next())
        { %>
                <tr>
                <td><%=rs.getString("username")%></td>
                <td><%=rs.getString("ProductID")%></td>
                <td><%=rs.getString("reportContent")%></td>
                <td><%=rs.getString("reportTime")%></td>
                <td><%=rs.getString("reportStatus")%></td>
                <td><a href="report_deal.jsp?reportId=<%=rs.getInt("reportId")%>">处理</a></td>
            </tr>
        <% } 
        }catch(Exception e){
        e.printStackTrace();
        }
        %>
           </tbody>
    </table>
</form>
        </div>
    </div>
<script >
    $(document).ready(function(){

        $('#all').click(function(){
            $('input:checkbox[name]').prop('checked',this.checked);
        });

        $('input:checkbox[name]').click(function(){
            isall=$('input:checkbox[name]').length==$('input:checkbox[name]:checked').length;
            $('#all').prop('checked',isall);
        });
    });
</script>
</body>
</html>
